Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBTIMEZONE

Syntax

Description of the illustration dbtimezone.gif

Purpose

`DBTIMEZONE` returns the value of the database time zone. The return type is a time zone offset (a character type in the format `'[+|-]TZH:TZM'`) or a time zone region name, depending on how the user specified the database time zone value in the most recent `CREATE` `DATABASE` or `ALTER` `DATABASE` statement.

Examples

The following example assumes that the database time zone is set to UTC time zone:

    SELECT DBTIMEZONE FROM DUAL;

    DBTIME
    ------
    +00:00